1100 |
Is it is possible to exclude the non-working days when displaying the histogram using the exBarEffort for exHistOverAllocation type
|
1099 |
I display numbers in my chart, but the AddBar requires a date how can I add a bar
Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.NonworkingDays = 0 var_Chart.FirstVisibleDate = 0 var_Chart.ToolTip = "" var_Level = var_Chart.Level(0) var_Level.Label = "<%i%>" var_Level.ToolTip = "" var_Chart.UnitWidth = 24 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2,4) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",6,10) oG2antt.EndUpdate() |
1098 |
I display numbers in the chart's header but do not want to get displayed negative numbers. How can i do that
' Occurs when the first visible date is changed. function DateChange as v () oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Chart.FirstVisibleDate = 0 oG2antt.Template = "ScrollPartEnable(2,1024) = False" // oG2antt.ScrollPartEnable(2,1024) = .f. end function Dim oG2antt as P Dim var_Chart as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.NonworkingDays = 0 var_Chart.FirstVisibleDate = 0 var_Chart.ToolTip = "" var_Level = var_Chart.Level(0) var_Level.Label = "<%i%>" var_Level.ToolTip = "<%i%>" var_Chart.UnitWidth = 24 oG2antt.EndUpdate() |
1097 |
How can I display numbers in the chart's header instead dates
|
1096 |
How can I create a bar that's not sizable, or can not be resized by default similar with milestone
Dim oG2antt as P Dim var_Bar as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {12/24/2000} var_Chart.LevelCount = 2 var_Bar = var_Chart.Bars.Add("Custom") var_Bar.Shape = 0 var_Bar.StartShape = 1 var_Bar.EndShape = 0 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem(""),"Custom",{01/02/2001},{01/02/2001},"K1","This TYPE of bar can not be resized.") oG2antt.EndUpdate() |
1095 |
Is it possible to hide the non-working parts for items using the ItemNonworkingUnits, even if set the ShowNonworkingUnits, ShowNonworkingDates on False
|
1094 |
Is it possible to show the non-working parts for certain items, even if I hide the default non-working part
|
1093 |
How can I hide the non-working part of the chart
Dim oG2antt as P Dim var_Chart as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2008} ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.LevelCount = 2 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. oG2antt.EndUpdate() |
1092 |
Is it possible to let users selects cells as in Excel
Dim h as N Dim h1 as N Dim oG2antt as P Dim var_Column as P Dim var_Column1 as P Dim var_Column2 as P Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.FullRowSelect = 1 oG2antt.SingleSel = .f. oG2antt.ReadOnly = -1 oG2antt.MarkSearchColumn = .f. oG2antt.ShowFocusRect = .f. oG2antt.LinesAtRoot = -1 oG2antt.SelForeColor = 0 oG2antt.SelBackColor = 15917512 var_Columns = oG2antt.Columns var_Columns.Add("A") var_Column = var_Columns.Add("B") var_Column.AllowSizing = .f. var_Column.Width = 24 var_Column1 = var_Columns.Add("C") var_Column1.AllowSizing = .f. var_Column1.Width = 24 ' var_Column1.Def(0) = 1 oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Def(0) = 1" var_Column1.PartialCheck = .t. var_Column2 = var_Columns.Add("D") var_Column2.AllowSizing = .f. var_Column2.Width = 24 ' var_Column2.Def(1) = 1 oG2antt.TemplateDef = "dim var_Column2" oG2antt.TemplateDef = var_Column2 oG2antt.Template = "var_Column2.Def(1) = 1" var_Items = oG2antt.Items h = var_Items.InsertItem(,,"Group 1") h1 = var_Items.InsertItem(h,,16) ' var_Items.CellValue(h1,1) = 17 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 17" h1 = var_Items.InsertItem(h,,2) ' var_Items.CellValue(h1,1) = 11 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 11" h1 = var_Items.InsertItem(h,,2) ' var_Items.ItemBackColor(h1) = 15790320 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBackColor(h1) = 15790320" ' var_Items.CellValue(h1,1) = 9 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 9" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.InsertItem(,,"Group 2") ' var_Items.CellValueFormat(h,2) = 1 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValueFormat(h,2) = 1" h1 = var_Items.InsertItem(h,,16) ' var_Items.CellValue(h1,1) = 9 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 9" h1 = var_Items.InsertItem(h,,12) ' var_Items.CellValue(h1,1) = 11 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 11" h1 = var_Items.InsertItem(h,,2) ' var_Items.CellValue(h1,1) = 2 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 2" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.SelectItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.SelectItem(h) = True" oG2antt.EndUpdate() |
1091 |
How can I hide a date from the chart view
Dim oG2antt as P Dim var_Chart as P Dim var_InsideZooms as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2008} ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.LevelCount = 2 var_Chart.AllowInsideZoom = .t. var_Chart.AllowResizeInsideZoom = .f. var_Chart.InsideZoomOnDblClick = .f. var_InsideZooms = var_Chart.InsideZooms var_InsideZooms.SplitBaseLevel = .f. var_InsideZooms.DefaultWidth = 0 var_InsideZooms.Add({01/04/2008}) var_InsideZooms.Add({01/05/2008}) var_InsideZooms.Add({01/06/2008}) var_Chart.SelectLevel = 1 ' var_Chart.SelectDate({01/05/2008}) = .t. oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.SelectDate(#1/5/2008#) = True" oG2antt.EndUpdate() |
1090 |
Can the SchedulePDM displays and edit the working units for my bars
|
1089 |
Can the SchedulePDM displays the working units for my bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Column as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Items.AllowCellValueToItemBar = .t. oG2antt.Columns.Add("Task") ' oG2antt.Columns.Add("Working").Def(18) = 258 var_Column = oG2antt.Columns.Add("Working") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(18) = 258" var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 96 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 96" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L1",h1,"",h2,"") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"") var_Items.AddLink("L2",h2,"",h3,"") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L3",h4,"",h3,"") ' var_Items.ItemBar(0,"<*>",20) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,20) = True" var_Items.SchedulePDM(var_Items.FirstVisibleItem,"") oG2antt.EndUpdate() |
1088 |
Can the SchedulePDM keeps the working units for my bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"K4") var_Items.AddLink("L3",h4,"K4",h3,"K3") ' var_Items.ItemBar(0,"<*>",20) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,20) = True" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1087 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"K4") var_Items.AddLink("L3",h4,"K4",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1086 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
' Occurs when a bar is moved or resized. function BarResize as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1085 |
I have some buttons added on the control's scroll bar, how can I can know when the button is being clicked
' Occurs when the user clicks a button in the scrollbar. function ScrollButtonClick as v (ScrollBar as OLE::Exontrol.G2antt.1::ScrollBarEnum,ScrollPart as OLE::Exontrol.G2antt.1::ScrollPartEnum) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? ScrollBar ? ScrollPart end function Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Template = "ScrollPartVisible(1,32768) = True" // oG2antt.ScrollPartVisible(1,32768) = .t. oG2antt.Template = "ScrollPartVisible(1,16384) = True" // oG2antt.ScrollPartVisible(1,16384) = .t. oG2antt.Template = "ScrollPartVisible(1,1) = True" // oG2antt.ScrollPartVisible(1,1) = .t. oG2antt.Template = "ScrollPartVisible(1,2) = True" // oG2antt.ScrollPartVisible(1,2) = .t. oG2antt.ScrollBars = 5 |
1084 |
How do I get notified once the user clicks a hyperlink created using the anchor HTML tag
' Occurs when an anchor element is clicked. function AnchorClick as v (AnchorID as C,Options as C) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? AnchorID ? Options end function Dim oG2antt as P Dim var_Column as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Default").Def(17) = 1 var_Column = oG2antt.Columns.Add("Default") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(17) = 1" var_Items = oG2antt.Items var_Items.AddItem("This is a link: <aex.com;1>www.exontrol.com</a>") var_Items.AddItem("This is a link: <aex.net;2>www.exontrol.net</a>") |
1083 |
Is it possible to start editing a cell when double click it
' Occurs when the user dblclk the left mouse button over an object. function DblClick as v (Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Edit() end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.AutoEdit = .f. oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1082 |
Is it possible to disable standard single-click behavior for this column, so I manually could call Edit() when needed
' Occurs when the user dblclk the left mouse button over an object. function DblClick as v (Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Edit() end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.AutoEdit = .f. oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1081 |
How can I get or restore the old or previously value for the cell being changed
' Occurs when the user changes the cell's content. function Change as v (Item as OLE::Exontrol.G2antt.1::HITEM,ColIndex as N,NewValue as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? "Old-Value:" ? oG2antt.Items.CellValue(Item,ColIndex) ? "New-Value:" ? NewValue end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1080 |
How can I display the number of items being found after filtering
' Occurs when the filter was changed. function FilterChange as v () oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.FilterBarCaption = oG2antt.Items.VisibleCount end function Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 1 oG2antt.FilterBarPromptPattern = "london" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1079 |
How can I highligth the item from the cursor as it moves
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() h = oG2antt.ItemFromPoint(-1,-1,c,hit) var_Items = oG2antt.Items var_Items.ClearItemBackColor(oG2antt.Background(1000 '200 + exHSRight + exListOLEDropPosition)) ' var_Items.ItemBackColor(h) = 15792880 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBackColor(h) = 15792880" oG2antt.Template = "Background(1000) = h" // oG2antt.Background(1000 '200 + exHSRight + exListOLEDropPosition) = h oG2antt.EndUpdate() end function Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = 1 oG2antt.SelBackColor = 15792880 oG2antt.SelForeColor = 0 oG2antt.ShowFocusRect = .f. var_Chart = oG2antt.Chart var_Chart.SelBackColor = 15792880 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1078 |
How can I get the item from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N oG2antt = topparent:CONTROL_ACTIVEX1.activex h = oG2antt.ItemFromPoint(-1,-1,c,hit) ? "Handle" ? h ? "Index" ? oG2antt.Items.ItemToIndex(h) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = 1 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1077 |
How can I get the column from the cursor, not only in the header
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? oG2antt.ColumnFromPoint(-1,0) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("P1") oG2antt.Columns.Add("P2") oG2antt.DrawGridLines = -1 var_Items = oG2antt.Items h = var_Items.AddItem("R1") ' var_Items.CellValue(h,1) = "R2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `R2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 1.1"),1) = "Cell 1.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 1.1`),1) = `Cell 1.2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 2.1"),1) = "Cell 2.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 2.1`),1) = `Cell 2.2`" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1076 |
How can I get the column from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? oG2antt.ColumnFromPoint(-1,-1) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = -1 oG2antt.Columns.Add("P1") oG2antt.Columns.Add("P2") var_Items = oG2antt.Items h = var_Items.AddItem("R1") ' var_Items.CellValue(h,1) = "R2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `R2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 1.1"),1) = "Cell 1.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 1.1`),1) = `Cell 1.2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 2.1"),1) = "Cell 2.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 2.1`),1) = `Cell 2.2`" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1075 |
How can I get the cell's caption from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N oG2antt = topparent:CONTROL_ACTIVEX1.activex h = oG2antt.ItemFromPoint(-1,-1,c,hit) ? oG2antt.Items.CellCaption(h,c) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1074 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 33 'exGridLinesVSolid + exGridLinesHDot4 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") oG2antt.Columns.Add("C3") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") ' var_Items.CellValue(h,1) = "SubItem 1.2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `SubItem 1.2`" ' var_Items.CellValue(h,2) = "SubItem 1.3" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `SubItem 1.3`" h = var_Items.AddItem("Item 2") ' var_Items.CellValue(h,1) = "SubItem 2.2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `SubItem 2.2`" ' var_Items.CellValue(h,2) = "SubItem 2.3" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `SubItem 2.3`" oG2antt.EndUpdate() |
1073 |
How can I show the bars over the grid lines, i.e. so you cannot see the grid lines 'through' the bar
|
1072 |
Is it possible to change the style for the vertical grid lines, in the chart area only
|
1071 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
|
1070 |
How can I show the grid lines for the chart and list area
|
1069 |
In the level of the chart we are showing the week number of the year (1-53) (Week: ww). However the weeknumber isn't correct. In western Europe the week of 04/01/2010 till 10/01/2010 is weeknumber 1, however the g2antt says it's week 2
|
1068 |
How can I determine the current visible date range of the gantt chart area
Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",{01/02/2001},{01/06/2001}) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/03/2001},{01/07/2001}) var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",{01/04/2001},{01/08/2001}) var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/06/2001},{01/10/2001}) ? oG2antt.Chart.StartPrintDate ? oG2antt.Chart.EndPrintDate |
1067 |
How can I change the progress bar using a spin editor using values from 0 to 100
|
1066 |
Is it possible to display the histogram for selected bars only
|
1065 |
How can I fix a bar, so it is not selectable, moveable or resizable, fixed in other words
Dim h1 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/08/2001},"K1","Unselectable") ' var_Items.ItemBar(h1,"K1",29) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,29) = False" oG2antt.EndUpdate() |
1064 |
How can I fix a bar, so it is not moveable or resizable
Dim h1 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1","Fixed") ' var_Items.ItemBar(h1,"K1",10) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,10) = False" ' var_Items.ItemBar(h1,"K1",11) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,11) = False" oG2antt.EndUpdate() |
1063 |
Is is possible to fix a bar during PDM scheduling
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"TaskF",{01/02/2001},{01/04/2001},"K1") ' var_Items.ItemBar(h1,"K1",10) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,10) = False" ' var_Items.ItemBar(h1,"K1",11) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,11) = False" h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"TaskF",{01/02/2001},{01/04/2001},"K3") ' var_Items.ItemBar(h3,"K3",10) = .f. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,10) = False" ' var_Items.ItemBar(h3,"K3",11) = .f. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,11) = False" var_Items.AddLink("L2",h2,"K2",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1062 |
How can I specify that during scheduling the link, bars should be delayed, on working part
|
1061 |
How can I specify that during scheduling the link, bars should be delayed
|
1060 |
The SchedulePDM method put the bars on non-working part, how can I prevent that
|
1059 |
How can I add a SF (Start-Finish) link so activities get arranged using the SchedulePDM
|
1058 |
How can I add a SS (Start-Start) link so activities get arranged using the SchedulePDM
|
1057 |
How can I add a FF (Finish-Finish) link so activities get arranged using the SchedulePDM
|
1056 |
How can I add a FS (Finish-Start) link so activities get arranged using the SchedulePDM
|
1055 |
How can I schedule activities in the project plan
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddLink("L2",h3,"K3",h2,"K2") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1054 |
How do I arrange the bars based on the links
|
1053 |
Is is possible to use HTML tags to display in the filter caption
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarCaption = "This is a bit of text being displayed in the filter bar." oG2antt.Columns.Add("") var_Items = oG2antt.Items var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") var_Items.AddItem("Item 3") oG2antt.EndUpdate() |
1052 |
How can I find the number of items after filtering
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("") var_Items = oG2antt.Items h = var_Items.AddItem("") ' var_Items.CellValue(h,0) = var_Items.VisibleItemCount oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = VisibleItemCount" oG2antt.EndUpdate() |
1051 |
How can I change the filter caption
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12801 'exFilterPromptWords + exFilterPromptContainsAll oG2antt.FilterBarPromptPattern = "london robert" oG2antt.FilterBarCaption = "<r>Found: ... " var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1050 |
While using the filter prompt is it is possible to use wild characters
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 16 oG2antt.FilterBarPromptPattern = "lon* seat*" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1049 |
How can I list all items that contains any of specified words, not necessary at the beggining
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4610 'exFilterPromptStartWords + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "london davolio" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1048 |
How can I list all items that contains any of specified words, not strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12802 'exFilterPromptWords + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "london nancy" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1047 |
How can I list all items that contains all specified words, not strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12801 'exFilterPromptWords + exFilterPromptContainsAll oG2antt.FilterBarPromptPattern = "london robert" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1046 |
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 258 'exFilterPromptCaseSensitive + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "Anne" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1045 |
Is it possible to list only items that ends with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "Fuller" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1044 |
Is it possible to list only items that ends with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "Fuller" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1043 |
Is it possible to list only items that starts with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 3 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "An M" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1042 |
Is it possible to list only items that starts with specified string
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 3 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "A" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1041 |
How can I specify that the list should include any of the seqeunces in the pattern
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 2 oG2antt.FilterBarPromptPattern = "london seattle" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1040 |
How can I specify that all sequences in the filter pattern must be included in the list
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 1 oG2antt.FilterBarPromptPattern = "london manager" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1039 |
How do I change at runtime the filter prompt
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptPattern = "london manager" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1038 |
How do I specify to filter only a single column when using the filter prompt
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptColumns = "2,3" oG2antt.FilterBarPromptPattern = "london" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1037 |
How do I change the prompt or the caption being displayed in the filter bar
Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPrompt = "changed" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") oG2antt.EndUpdate() |
1036 |
How do I enable the filter prompt feature
|
1035 |
How can I unselect all bars
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",{01/02/2001},{01/04/2001},"K1") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"K4") ' var_Items.ItemBar(0,"<*>",257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,257) = True" ' var_Items.ItemBar(0,"<*>",257) = .f. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,257) = False" |
1034 |
Can I select bars using a pattern using wild characters as *,
|
1033 |
How can I select all bars in the item with a specified key
|
1032 |
How can I select all bars in the specified item
|
1031 |
How can I select all bars with a specified key
|
1030 |
How can I select all bars
|
1029 |
I have the AllowInsideZoom property on True, but I am still not able to use the inside zoom feature
|
1028 |
Is there any option to find out if two bars intersects
|
1027 |
How can I find if a specified hour is a working or non-working hour, when using the ItemNonWorkingUnits
|
1026 |
How can I find if a specified hour is a working or non-working hour
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Hour").FormatColumn = "hour(value)" var_Column = oG2antt.Columns.Add("Hour") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.FormatColumn = `hour(value)`" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 164 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 164" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.UnitScale = 65536 var_Chart.NonworkingHours = 1 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/01/2001 01:00:00}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1025 |
How can I find if a specified date-time is a working or non-working unit, when using the ItemNonWorkingUnits
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Date").Width = 48 var_Column = oG2antt.Columns.Add("Date") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 48" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 128 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 128" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/01/2001}) ' var_Items.ItemNonworkingUnits(h,.f.) = "weekday(value) in (1)" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemNonworkingUnits(h,False) = `weekday(value) in (1)`" w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0),h) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1024 |
How can I find if a specified date-time is a working or non-working unit
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Date").Width = 48 var_Column = oG2antt.Columns.Add("Date") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 48" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 128 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 128" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/06/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1023 |
When zooming to days, the non-working part of the chart occupies some not useful space. Can I reduce it
|
1022 |
My chart display only working hours, but when zooming to days, each day shows the non-working part of the day too, even if I use the ShowNonWorkingUnits property on False. What am I doing wrong
|
1021 |
I need to display only working hours and weekend part, but for some items I need another non-working part. Is this possible
|
1020 |
I can display the working hours, but how can I hide the weekend or non-working part of the chart when using the ShowNonWorkingUnits property on False
|
1019 |
How can I display only the working hours but uses less space for non-working part, such as weekend
|
1018 |
How can I display only the working hours but uses less space for non-working part, such as weekend
|
1017 |
How can I display only the working hours
|
1016 |
How can I specify non-working hours
|
1015 |
How can I display the working hours for a bar
|
1014 |
Is it possible to show only working hours, showing a small part for the weekend days, and in the same time showing the bars by splitting the non-working part and keeping the working units for the bar while moving
|
1013 |
How can I show bars with different solid color but black border
|
1012 |
I want to display a vertical line for each week, while I still need a vertical separator for each day. Is this possible
|
1011 |
How can I display the levels as year, day, AM and PM for each day
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as local Dim var_Level2 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {12/01/2009} var_Chart.UnitWidth = 22 var_Chart.LevelCount = 3 ' var_Chart.Level(0).Label = "<%yyyy%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%yyyy%>`" ' var_Chart.Level(1).Label = "<%mm%>/<%dd%>" var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = `<%mm%>/<%dd%>`" var_Level2 = var_Chart.Level(2) var_Level2.Label = "<%AM/PM%>" var_Level2.Count = 12 |
1010 |
How can I change the pattern for a specified time unit, in the chart area
|
1009 |
How can I hide the non-working hours, but still display the non-working days with even less space
|
1008 |
How can I hide the non-working hours, but still display the non-working days with less space
|
1007 |
How can I hide the non-working hours, but still display the non-working days
|
1006 |
How can I hide the non-working hours, and the non-working days
|
1005 |
Can I highlights the non-working hours while my chart shows days
|
1004 |
How can I reduce the space/area being occupied by non-working units days or hours (method 2)
|
1003 |
How can I reduce the space/area being occupied by non-working units days or hours (method 1)
|
1002 |
How can I hide the non-working units
|
1001 |
How can I determine that a certain bar is the topmost (zorder)
|